UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tTImbHlxYWx5p6ehBETCZHIQs/HqahndK/0s6XUs8q8='
WHERE
key_id = 'fad5e3fdb0752cd06408298d17a41c163a9a6d4855a487db6f943fa00c58c62e'
AND (
token = 'tTImbHlxYWx5p6ehBETCZHIQs/HqahndK/0s6XUs8q8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)