SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '238fe49643766f0644d5f87a26a61bcf20f557321ba325b02ce5f854f062a943' 
  AND token = 'bzxXUm7S13xmGl7KksTuRZFeAr2U5wwgaX6RQDw6lJI=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00024

JSON explain

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