UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'UgqxZG697Cu/G+Y5bX9KCYng3rrOCYjjr1E/+IiloPU=' 
WHERE 
  key_id = '8f10c1470529775804c7e68590a8472db8c1d3ab7c28eea012946ae29dc372df' 
  AND (
    token = 'UgqxZG697Cu/G+Y5bX9KCYng3rrOCYjjr1E/+IiloPU=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00039