UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1CZr9n0dwJ/JhlG0cgkiyhXdnarCrYfHZpJegIsj1u0='
WHERE
key_id = '7fec54aa795ef89c4224b143df505f3a2ff82387a5757b4fc7aec6c267e9240c'
AND (
token = '1CZr9n0dwJ/JhlG0cgkiyhXdnarCrYfHZpJegIsj1u0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)