UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5arHEEXYU8sCZiaFnWvymI9UBwy3neZmbFLAN8/kymo='
WHERE
key_id = 'a1ab336ccb343efd3c939ef059f4797dc28e8e1c21613ad73fc46437477dbb90'
AND (
token = '5arHEEXYU8sCZiaFnWvymI9UBwy3neZmbFLAN8/kymo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)