UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '6ioFVuDa+D/BNX6XAhIxvwtBlyff5W75wlufM25F0E0=' 
WHERE 
  key_id = 'ffdbf6ccba4bf23dcb114b0db1e72357a427ce0e49ca8f5fde73fd49fd50ba66' 
  AND (
    token = '6ioFVuDa+D/BNX6XAhIxvwtBlyff5W75wlufM25F0E0=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00027