UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1ph/hxMNq/aw7x6/G2JTp4acPAuq7YMl1DSt3abYfc0='
WHERE
key_id = 'd1e252dd5cf5b618e839e71e8786b157caf817269c64c4804274b575c3962dd8'
AND (
token = '1ph/hxMNq/aw7x6/G2JTp4acPAuq7YMl1DSt3abYfc0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)