UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'capwXdq5LcVqzZUAJNujqL3vYEHinNE83zHnAd/PqwI=' 
WHERE 
  key_id = '42c22a3f4df95041437cda87c3e2b14e734d046b6aadd0260f59a2b4eb6b1ed0' 
  AND (
    token = 'capwXdq5LcVqzZUAJNujqL3vYEHinNE83zHnAd/PqwI=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00030