UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Be8IB2PnRux8k1zqHBIitiqSf6ZgcOG2ncpkHJnQj1g='
WHERE
key_id = '4c074b3407968f151dcf602f87ee65344ca3eda19c7ee0eac8b5838da4d1506f'
AND (
token = 'Be8IB2PnRux8k1zqHBIitiqSf6ZgcOG2ncpkHJnQj1g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)