UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QIdswuXKwIoHvsOvUvtaGQUVdIkTSu+DaLHFmbVBU/o='
WHERE
key_id = 'b5476ce7c7660300ab277c0cb0b649d1d1686981c6230de476f819ca21c1aeda'
AND (
token = 'QIdswuXKwIoHvsOvUvtaGQUVdIkTSu+DaLHFmbVBU/o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)