UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pRoHkhksslR2JaERnvI6bNNzOUvQOfz3ESKFvxW8Gvo='
WHERE
key_id = '0c518adde89d49a01fc656878a1f6c18f21d832cbaac4b9e33fd03d7eba063b1'
AND (
token = 'pRoHkhksslR2JaERnvI6bNNzOUvQOfz3ESKFvxW8Gvo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)