UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'i25YfYUuy+AjiGhXR3kOr8NbkYll7vjxVJSwduYZEII='
WHERE
key_id = '0791923ab84c168e8ef9ebf852cc0e27d7e0ec7471899bef2b98ccdc36efe9ac'
AND (
token = 'i25YfYUuy+AjiGhXR3kOr8NbkYll7vjxVJSwduYZEII='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)