UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'b947vm7t5iFYOQsA61uA9p/X+B4+/rkkIgYB4edj6qQ='
WHERE
key_id = '06bfa083c7aeccd5b454e6a0a1604f2e1c14a18f3c55ec1a1b5468ee85a70f99'
AND (
token = 'b947vm7t5iFYOQsA61uA9p/X+B4+/rkkIgYB4edj6qQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)