UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4qxZa04FjPkHYWnWg7+SeroKSgeXLDlwi4aDHBouDrk='
WHERE
key_id = 'c537c568d694c81f093bd53f8ec12cab801445b48a0c1feaf1529eb8359edc66'
AND (
token = '4qxZa04FjPkHYWnWg7+SeroKSgeXLDlwi4aDHBouDrk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)