UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'EL6cEjs2ehXQ+KzmY9zu00bVsNEZMLNryriKUNwD02o=' 
WHERE 
  key_id = 'c2b2dc42e46534f73472a704754a5d3be89a3a809837038078d89a8cf1f4a391' 
  AND (
    token = 'EL6cEjs2ehXQ+KzmY9zu00bVsNEZMLNryriKUNwD02o=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00045