UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'allepR4+KIT0Y/HTOwc1GUS89juiTCV6o97eVD+MOKU='
WHERE
key_id = 'dc8477c0a3eb44ab780b9114fa4f0a609a25902ef2bde5510939045a38b104e8'
AND (
token = 'allepR4+KIT0Y/HTOwc1GUS89juiTCV6o97eVD+MOKU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)