UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oLkYn11ffnJwF82hE1Vve3LMGdPoAknmcTl1wlGi8ak='
WHERE
key_id = '3d3d69372f2da708e06dda7dbec101dc94f073d629498f6b3b35fa93be64a5fc'
AND (
token = 'oLkYn11ffnJwF82hE1Vve3LMGdPoAknmcTl1wlGi8ak='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)