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

Query time 0.00033