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