UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XoDIP6DhAWg9R5qDt+NIBiRRq+4kysqGqMzkD9FHO3A='
WHERE
key_id = 'a27fb12d52d801b5d1d1a91645888f1f328a407e89f7bc5b1ee93cc1e26c6607'
AND (
token = 'XoDIP6DhAWg9R5qDt+NIBiRRq+4kysqGqMzkD9FHO3A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)