UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cSaQQYC3e4/+/2YgBOBh3beCrQoVbekxnct4/QtOcXY='
WHERE
key_id = 'ced6b781bede44a8f5ac6dbddd94a117aea7c8dc4f7bf3f826b2792ea506bc19'
AND (
token = 'cSaQQYC3e4/+/2YgBOBh3beCrQoVbekxnct4/QtOcXY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)