UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '+IbbrMFEv2nj+YbPJL1TNFBg2FuS1e6fzCSY2QwFCmA=' 
WHERE 
  key_id = 'aadf380f1d1cbe3a394d25740f528e5da1e722d415947b05ba7a1a90cea1b50f' 
  AND (
    token = '+IbbrMFEv2nj+YbPJL1TNFBg2FuS1e6fzCSY2QwFCmA=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00033