UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bGEE9zIRIptnhwYov7Z70Drg/xGxp6YpXf+V29FVvb4='
WHERE
key_id = 'c2a4924e1dca9e731876607c4c5076abd8d4ebb7aa9bf4d3c251f93ee42309e6'
AND (
token = 'bGEE9zIRIptnhwYov7Z70Drg/xGxp6YpXf+V29FVvb4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)