SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '81224d4f080bc40c9feedd932bd752d29f7ba57d9c04a1ad7e1d6690b7416459' 
  AND token = 'rnYoGNlkeWdRwi3+2Z8Bmj21mwGv2lyc0hu3M8TJYnY=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00010

JSON explain

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