UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'e0z1uX8EF4aaZZ5NMBqw09a05JfU+5WLB0AuPJ17ENQ=' 
WHERE 
  key_id = '2874f76d27b42e2219eee6f62659facc66d7f80b0184ef654e90e9c4bc21071b' 
  AND (
    token = 'e0z1uX8EF4aaZZ5NMBqw09a05JfU+5WLB0AuPJ17ENQ=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00021