UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'vNYiOH1Nhrcq/nhnHdilNi/DRxnxB08aINCG5as4LI4=' 
WHERE 
  key_id = '6d300482c2747b31423f99fbfe9a43baa0b9cd731c56bf46d271a2f01b5fb0d7' 
  AND (
    token = 'vNYiOH1Nhrcq/nhnHdilNi/DRxnxB08aINCG5as4LI4=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00030