UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'Th6OSJhra03m4+ED949TNPv2Jan1La5H68RgkJQODRg=' 
WHERE 
  key_id = 'd6835ce1dc5f478875b80139492febcccd7262851028835a71db62399dec553a' 
  AND (
    token = 'Th6OSJhra03m4+ED949TNPv2Jan1La5H68RgkJQODRg=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00057