SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '65d991feab2139c9303f12a4d0c621ef53a1e152e374a2022268e4938d7dc6a1' 
  AND token = 'qOx33Re0eve1fFGNS0dOAANDbu4JwpYu7JJNB0hPfbw=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00030

JSON explain

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