UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'FXuKtPzFRTOKCtClJfOOuo6dK0svTQp5WaVuACGDID4='
WHERE
key_id = 'd80c243b02fab5e59163a84f0e56516c00479bc62700fa59bf6ca7e3a17bc27e'
AND (
token = 'FXuKtPzFRTOKCtClJfOOuo6dK0svTQp5WaVuACGDID4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)