UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hgL3PVNl/SYhxuKhu39a98ujkPa/z5MQS1NjxSKAwVM='
WHERE
key_id = '20a50f5407223a5bbca193d47fa47a6aa03668cc75953795746c6b6c14a62f0f'
AND (
token = 'hgL3PVNl/SYhxuKhu39a98ujkPa/z5MQS1NjxSKAwVM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)