UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BMX9WhrYzcfagymIXIijy+DlEsRby913vCsFhh4qzzA='
WHERE
key_id = 'c4794cf7211ef035c437142a23e3adb17a522b801ee105923a7943e1d9b6f47f'
AND (
token = 'BMX9WhrYzcfagymIXIijy+DlEsRby913vCsFhh4qzzA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)