UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WEIau1H1yQqbGYJk8CBe7fxVxcmLumAlBhyZkt0jP6s='
WHERE
key_id = '3aa4edfcf3657802b31e5dbd4bd5232243d90f5a32f1e6862f2fb9f8365a2cc1'
AND (
token = 'WEIau1H1yQqbGYJk8CBe7fxVxcmLumAlBhyZkt0jP6s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)