UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'W4zrqzOXwHm8Vqy/NfhtPxtDWnxY8fwZYIgxbL6pV5Y='
WHERE
key_id = '08716b3020a854b5c1c99be3f6c4f14bc89c63904a9e36223a206a2e97c6c3b9'
AND (
token = 'W4zrqzOXwHm8Vqy/NfhtPxtDWnxY8fwZYIgxbL6pV5Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)