UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'ZlNDYwM2sR1HATVSE/+misl69l9jQD9gM9Ljxk7/Wn8=' 
WHERE 
  key_id = '88239781a5f86e783c1de9c47ba58d70036d4b851b6fa273ce8c38282a770170' 
  AND (
    token = 'ZlNDYwM2sR1HATVSE/+misl69l9jQD9gM9Ljxk7/Wn8=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00044