SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '1b9f8e203ff517e0e9e41d6c3fcaac76d2c3160cb6f9902a3c0a18c4e192ed6f' 
  AND token = 'VjXTkIyzS2T+6V4uJFz9CXOQ62n9ustRuSsWlT4L+MI=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00017

JSON explain

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