UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '49/L/F4wY9q6mAaMFzrYyb0TMMkPBHADlO3W6sv0ZmU=' 
WHERE 
  key_id = '85fbb38cf6e6919a2f5ee3b6e61210af9d91c6d1dbc26d57f5aa7e488aac7db8' 
  AND (
    token = '49/L/F4wY9q6mAaMFzrYyb0TMMkPBHADlO3W6sv0ZmU=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00048