SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '6f2a59c00db22bdb4ee4c6236c08521344f200ab5029be7b13c1f31430aa405e' 
  AND token = 'sUL7q7FRrTuTvNZMD1nQqGKao1pzdiM9Y6W5LiNZk54=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00048

JSON explain

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