UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'zx80Fj85P2ndoS6bZWhW0ZKmt/6+uaqDT2YGVZe+BMU=' 
WHERE 
  key_id = '805912d59a5f235b05149a0f8b1926495088d92f04ec27df15fb9760f0f9e58e' 
  AND (
    token = 'zx80Fj85P2ndoS6bZWhW0ZKmt/6+uaqDT2YGVZe+BMU=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00060