SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '399557032c26ce9df6d41771a91c7f6a0272f45221fd98c783697428f4a5252b' 
  AND token = 'mqnfo1jRqy9F5UpmQRJB9zPWn8jKYF4jAFsS1ifBwEs=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00018

JSON explain

{
  "query_block": {
    "select_id": 1,
    "message": "no matching row in const table"
  }
}