UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'WiI4VjzJM24whuPsLeUEkol82bYeRdA4H3QqWwO+tXA=' 
WHERE 
  key_id = 'ea98a67ecd0a02f7e922a5a2d617c7bc1b3cc20c6c10a064a9a380c75b1c7909' 
  AND (
    token = 'WiI4VjzJM24whuPsLeUEkol82bYeRdA4H3QqWwO+tXA=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00027