UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'dMz1td7IpcR32zY7rnraUrsB5jHRfgx/HV6VjJ0KoIw=' 
WHERE 
  key_id = '7eb1d8980a1a6424ce94ff9fc0745b6aa74c682a5eac7d6e85745e0d06fdb09d' 
  AND (
    token = 'dMz1td7IpcR32zY7rnraUrsB5jHRfgx/HV6VjJ0KoIw=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00043