UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zRGIyfXU+9f+VnUmKWV0vqnLMnFMFeabPZ7pUrvPkRk='
WHERE
key_id = 'e3fcce37bab8f0386b94b02b91640b399526a48d5d0d7a7756bf85fca02af9f0'
AND (
token = 'zRGIyfXU+9f+VnUmKWV0vqnLMnFMFeabPZ7pUrvPkRk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)