UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'KQteLIupJEitZYt6FD/lSU/5H3zP3Vl1Rd4udH5y2Ac=' 
WHERE 
  key_id = 'c0a8091be167b48c99213b6afc83a560d187cb3d597f92cb581c9f73ee7795cb' 
  AND (
    token = 'KQteLIupJEitZYt6FD/lSU/5H3zP3Vl1Rd4udH5y2Ac=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00031