UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'e1mRo8lGn7Ifkdh/+6/Fv7H1t8xjqP5ZDcjy0Z6q4jY=' 
WHERE 
  key_id = '55a51aa72fb5456a5d4de29a5e1b5b615becca0665e5d8b66452c6fa8131f6b0' 
  AND (
    token = 'e1mRo8lGn7Ifkdh/+6/Fv7H1t8xjqP5ZDcjy0Z6q4jY=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00034