UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vZLgPYJZgpWsjaXHOdn38FRsTIgNDrvUuY+6+qINCK8='
WHERE
key_id = '7e598b7c4ee9293451056291d23d738c30cf24b65ce29303c62bf67bd9ec1fc1'
AND (
token = 'vZLgPYJZgpWsjaXHOdn38FRsTIgNDrvUuY+6+qINCK8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)