UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Der2eIGMosq6ynmNFkaBkqz3UtgLZfPHWLamu5nMTv4='
WHERE
key_id = 'e0485382ee2322f5abce32b589fbfdb7bdd2dc7b1c5fb65a65b6e90fe010fad9'
AND (
token = 'Der2eIGMosq6ynmNFkaBkqz3UtgLZfPHWLamu5nMTv4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)