UPDATE 
  cscart_june_setuplock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '0W4KQyJcqb8ews4amBgzrL2yNy3JC3YKZhFy9FtlgqE=' 
WHERE 
  key_id = 'c018d54a929ece668a73ba4719fa0ec47c6265a93c654e054afea04ff2e3e7fd' 
  AND (
    token = '0W4KQyJcqb8ews4amBgzrL2yNy3JC3YKZhFy9FtlgqE=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00023